Bromley's Formal Wear Cash Flow Analysis | |||||||
Start Up | November | December | January | February | March | April | |
Cash On Hand | $ 85,000.00 | $ 85,000.00 | $ 88,293.52 | $ 983.60 | $ 179,290.30 | $ 54,668.68 | $ 46,248.82 |
Cash Receipts | |||||||
Cash Sales | $ 125,000.00 | $ 52,000.00 | $ 150,000.00 | $ - | $ - | $ - | |
Cash From Receivables | $ 150,000.00 | $ 125,000.00 | $ 140,000.00 | ||||
Salary Income VEC | $ 132,241.53 | $ 132,241.53 | $ 132,241.53 | $ 132,241.53 | $ 132,241.53 | $ 132,241.53 | |
Loan | $ 150,800.00 | ||||||
Total Cash Receipts | $ 150,800.00 | $ 257,241.53 | $ 184,241.53 | $ 432,241.53 | $ 132,241.53 | $ 257,241.53 | $ 272,241.53 |
Total Cash Available | $ 235,800.00 | $ 342,241.53 | $ 272,535.05 | $ 433,225.13 | $ 311,531.83 | $ 311,910.21 | $ 318,490.35 |
Cash paid Out | |||||||
Purchases | $ 148,065.77 | $ 165,675.77 | $ 148,065.77 | $ 151,000.77 | $ 159,805.77 | $ 153,935.77 | |
Salary Expense | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | |
Rent Expense | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | |
Repairs Expense | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | |
Alterations Expense | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | |
Dry Cleaning Expense | $ - | $ - | $ - | $ - | $ - | $ - | |
Advertising Expense | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | |
Supplies Expense | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | |
Insurance Expense | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | |
Misc. Expense | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | |
Payroll Taxes | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | |
Legal And Accounting | $ - | $ - | $ - | $ - | $ - | $ - | |
Utilities Expense | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | |
Bad Debts Expense | $ - | $ - | $ - | $ - | $ - | $ - | |
Interest Expense | $ 1,508.00 | $ 1,501.44 | $ 1,494.82 | $ 1,488.14 | $ 1,481.38 | $ 1,474.56 | |
Sub total | $ - | ||||||
Loan Payment | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | |
Capital Purchses | $ 150,800.00 | ||||||
Total Expenditures | $ 150,800.00 | $ 253,948.01 | $ 271,551.45 | $ 253,934.83 | $ 256,863.15 | $ 265,661.39 | $ 259,784.57 |
Total Cash Out | $ 150,800.00 | $ 253,948.01 | $ 271,551.45 | $ 253,934.83 | $ 256,863.15 | $ 265,661.39 | $ 259,784.57 |
Cash Balance | $ 85,000.00 | $ 88,293.52 | $ 983.60 | $ 179,290.30 | $ 54,668.68 | $ 46,248.82 | $ 58,705.78 |